Overview

Dataset info

Number of variables82
Number of observations90454
Missing cells844516 (11.4%)
Duplicate rows0 (0.0%)
Total size in memory203.2 MiB
Average record size in memory2.3 KiB

Variables types

CAT46
NUM19
BOOL16
DATE1

Reproduction info

Date of analysis2020-05-27 04:48:04.534707
Versionpandas-profiling v2.4.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download Configurationconfig.yaml

Warnings

Alternative_purchasing_group has 3423 (3.8%) missing values Missing
Alternative_purchasing_group has a high cardinality: 560 distinct values Warning
ATC has a high cardinality: 1109 distinct values Warning
Chemical_/_biological has 7502 (8.3%) missing values Missing
consumption has 7507 (8.3%) zeros Zeros
consumption_previous_year has a high cardinality: 2746 distinct values Warning
Current_consumption has 8473 (9.4%) zeros Zeros
Dangerous_material_is_charged_with_a_permit has 80243 (88.7%) missing values Missing
dangerous_substance has 80259 (88.7%) missing values Missing
Date_of_basket_entry has 40977 (45.3%) missing values Missing
Date_of_basket_entry has a high cardinality: 54 distinct values Warning
Description_Alternative_purchasing_group has 3423 (3.8%) missing values Missing
Description_Alternative_purchasing_group has a high cardinality: 560 distinct values Warning
Description_outline has 6729 (7.4%) missing values Missing
Description_outline has a high cardinality: 306 distinct values Warning
Description_outline_Binary has 6729 (7.4%) missing values Missing
European_patent_expires has 89166 (98.6%) missing values Missing
For_adults has 86594 (95.7%) missing values Missing
Form_of_giving has 52783 (58.4%) missing values Missing
GENERY_FATHER has 53625 (59.3%) missing values Missing
GENERY_FATHER has a high cardinality: 678 distinct values Warning
Inventory has 10341 (11.4%) zeros Zeros
Inventory_of_consumption_months is highly skewed (γ1 = 82.16846137) Skewed
Inventory_of_consumption_months has 32842 (36.3%) zeros Zeros
Main_outline has 6729 (7.4%) missing values Missing
Main_outline has a high cardinality: 306 distinct values Warning
Narcotic_/_psychotropic has 41151 (45.5%) missing values Missing
Plant has constant value "7350.0" Rejected
Prediction has 8927 (9.9%) zeros Zeros
Price_for_absolute_packaging has 1275 (1.4%) zeros Zeros
Quantity_in_absolute_packaging has a high cardinality: 54 distinct values Warning
Quantity_in_Packaging-Absolute has 1275 (1.4%) zeros Zeros
Quantity_in_packing-relative has 64593 (71.4%) zeros Zeros
Safety_Stock has 9495 (10.5%) zeros Zeros
Send_code_to_Omri has constant value "1.0" Rejected
Serving_form has 7785 (8.6%) missing values Missing
Serving_form has a high cardinality: 53 distinct values Warning
Serving_form_Binary has 7785 (8.6%) missing values Missing
skucode2 has a high cardinality: 3197 distinct values Warning
status has constant value "1.0" Rejected
Toxic_item has 7200 (8.0%) missing values Missing
type_of_packeging has 85083 (94.1%) missing values Missing
U#S#_Patent_Expires has 88923 (98.3%) missing values Missing
Validity_of_Ministry_of_Health_registration has 85912 (95.0%) missing values Missing
Validity_of_Ministry_of_Health_registration has a high cardinality: 83 distinct values Warning
VENDOR has a high cardinality: 150 distinct values Warning
Material_Type_bool is highly correlated with A_group_of_materials and 1 other fieldsHigh Correlation
A_group_of_materials is highly correlated with Material_Type_boolHigh Correlation
other_Budget is highly correlated with Material_Type_boolHigh Correlation
PAC is highly correlated with EAHigh Correlation
EA is highly correlated with PACHigh Correlation
Prediction is highly correlated with consumption and 1 other fieldsHigh Correlation
consumption is highly correlated with Prediction and 1 other fieldsHigh Correlation
Safety_Stock is highly correlated with consumption and 2 other fieldsHigh Correlation
Inventory is highly correlated with Safety_StockHigh Correlation
General_purpose_ is highly correlated with General_purposeHigh Correlation
General_purpose is highly correlated with General_purpose_High Correlation
month_year_ is highly correlated with month_yearHigh Correlation
month_year is highly correlated with month_year_High Correlation
Send_code_to_Omri is highly correlated with Plant and 1 other fieldsHigh Correlation
Plant is highly correlated with Send_code_to_Omri and 1 other fieldsHigh Correlation
status is highly correlated with Plant and 1 other fieldsHigh Correlation

Variables

A
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
79576
1
 
10878
ValueCountFrequency (%) 
0 79576 88.0%
 
1 10878 12.0%
 

A_Budget
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
71746
1
18708
ValueCountFrequency (%) 
0 71746 79.3%
 
1 18708 20.7%
 

A_group_of_materials
Real number (ℝ≥0)

HIGH CORRELATION
Distinct count37
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19411.27166
Minimum1000
Maximum20400
Zeros0
Zeros (%)0.0%
Memory size353.5 KiB
Mini histogram

Quantile statistics

Minimum1000
5-th percentile10170
Q120120
median20160
Q320190
95-th percentile20271
Maximum20400
Range19400
Interquartile range (IQR)70

Descriptive statistics

Standard deviation2688.875021
Coefficient of variation (CV)0.1385213224
Kurtosis10.00287005
Mean19411.27166
Median Absolute Deviation (MAD)1403.458419
Skewness-3.361444751
Sum1755827167
Variance7230048.879
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 1000. 1500. 6050. 10130. 10145. ... 20271.5 20273.5 20274.5 20338. 20400. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
20190 14723 16.3%
 
20100 11235 12.4%
 
20120 9449 10.4%
 
20130 7744 8.6%
 
20210 5920 6.5%
 
20140 5192 5.7%
 
20270 4324 4.8%
 
20220 3800 4.2%
 
20180 3707 4.1%
 
20110 3031 3.4%
 
Other values (27) 21329 23.6%
 
ValueCountFrequency (%) 
1000 112 0.1%
 
2000 2 < 0.1%
 
10100 739 0.8%
 
10120 5 < 0.1%
 
10140 18 < 0.1%
 
ValueCountFrequency (%) 
20400 75 0.1%
 
20276 799 0.9%
 
20275 9 < 0.1%
 
20274 75 0.1%
 
20273 1389 1.5%
 

A_group_of_materials_Binary
Real number (ℝ≥0)

Distinct count36
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.918482651
Minimum0.002205144602
Maximum16.23317199
Zeros0
Zeros (%)0.0%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0.002205144602
5-th percentile1.223855254
Q13.341896645
median6.527228023
Q312.3873998
95-th percentile16.23317199
Maximum16.23317199
Range16.23096685
Interquartile range (IQR)9.045503159

Descriptive statistics

Standard deviation5.053374404
Coefficient of variation (CV)0.638174588
Kurtosis-1.171548135
Mean7.918482651
Median Absolute Deviation (MAD)4.445250798
Skewness0.3483673692
Sum716258.4297
Variance25.53659286
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[2.20514460e-03 1.92950153e-02 2.15001599e-02 5.29234705e-02 8.32442087e-02 ... 7.53277396e+00 9.47826279e+00 1.14028027e+01 1.43102859e+01 1.62331720e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
16.23317199 14723 16.3%
 
12.3873998 11235 12.4%
 
10.41820567 9449 10.4%
 
8.5383199 7744 8.6%
 
6.527228023 5920 6.5%
 
5.724555388 5192 5.7%
 
4.76752263 4324 4.8%
 
4.189774744 3800 4.2%
 
4.08723552 3707 4.1%
 
3.341896645 3031 3.4%
 
Other values (26) 21329 23.6%
 
ValueCountFrequency (%) 
0.002205144602 2 < 0.1%
 
0.005512861506 5 < 0.1%
 
0.008820578409 8 < 0.1%
 
0.009923150711 9 < 0.1%
 
0.01874372912 17 < 0.1%
 
ValueCountFrequency (%) 
16.23317199 14723 16.3%
 
12.3873998 11235 12.4%
 
10.41820567 9449 10.4%
 
8.5383199 7744 8.6%
 
6.527228023 5920 6.5%
 

ABC
Categorical

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
C
49305
B
30271
A
10878
ValueCountFrequency (%) 
C 49305 54.5%
 
B 30271 33.5%
 
A 10878 12.0%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length1
Mean length1
Min length1
Scatter
Distinct count35
Unique (%)< 0.1%
Missing147
Missing (%)0.2%
Memory size706.8 KiB
20
14504
11
11556
13
9668
24
9056
14
8010
Other values (29)
37513
ValueCountFrequency (%) 
20 14504 16.0%
 
11 11556 12.8%
 
13 9668 10.7%
 
24 9056 10.0%
 
14 8010 8.9%
 
21 6052 6.7%
 
15 5254 5.8%
 
22 4072 4.5%
 
19 3955 4.4%
 
17 2889 3.2%
 
Other values (24) 15291 16.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length2.003250271
Min length2
Scatter

Affiliation_Group_Binary
Real number (ℝ≥0)

Distinct count34
Unique (%)< 0.1%
Missing147
Missing (%)0.2%
Infinite0
Infinite (%)0.0%
Mean8.716184966
Minimum0.005521811154
Maximum16.0176698
Zeros0
Zeros (%)0.0%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0.005521811154
5-th percentile1.080066262
Q14.496963004
median8.845941469
Q312.76200994
95-th percentile16.0176698
Maximum16.0176698
Range16.01214798
Interquartile range (IQR)8.265046935

Descriptive statistics

Standard deviation4.804353556
Coefficient of variation (CV)0.5511991284
Kurtosis-1.114125492
Mean8.716184966
Median Absolute Deviation (MAD)4.099280616
Skewness-0.02999692185
Sum787132.5157
Variance23.08181309
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
16.0176698 14504 16.0%
 
12.76200994 11556 12.8%
 
10.67697405 9668 10.7%
 
10.0905577 9056 10.0%
 
8.845941469 8010 8.9%
 
6.683600221 6052 6.7%
 
5.802319161 5254 5.8%
 
4.496963004 4072 4.5%
 
4.367752623 3955 4.4%
 
3.190502485 2889 3.2%
 
Other values (23) 15291 16.9%
 
ValueCountFrequency (%) 
0.005521811154 5 < 0.1%
 
0.006626173385 6 < 0.1%
 
0.007730535616 7 < 0.1%
 
0.01214798454 11 < 0.1%
 
0.02319160685 42 < 0.1%
 
ValueCountFrequency (%) 
16.0176698 14504 16.0%
 
12.76200994 11556 12.8%
 
10.67697405 9668 10.7%
 
10.0905577 9056 10.0%
 
8.845941469 8010 8.9%
 

Alternative_purchasing_group
Categorical

MISSING
HIGH CARDINALITY
Distinct count560
Unique (%)0.6%
Missing3423
Missing (%)3.8%
Memory size706.8 KiB
1734
 
2963
1591
 
1889
1875
 
1705
1068
 
1515
1823
 
1352
Other values (554)
77607
ValueCountFrequency (%) 
1734 2963 3.3%
 
1591 1889 2.1%
 
1875 1705 1.9%
 
1068 1515 1.7%
 
1823 1352 1.5%
 
1317 1309 1.4%
 
1053 1217 1.3%
 
1642 1027 1.1%
 
1027 965 1.1%
 
1354 952 1.1%
 
Other values (549) 72137 79.7%
 
(Missing) 3423 3.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length4
Min length4
Scatter

ATC
Categorical

HIGH CARDINALITY
Distinct count1109
Unique (%)1.2%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
1/0/1900
 
6595
ATC:
 
1096
ATC:M01AE01
 
887
ATC:C10AA07
 
631
ATC:C10AA05
 
622
Other values (1104)
80623
ValueCountFrequency (%) 
1/0/1900 6595 7.3%
 
ATC: 1096 1.2%
 
ATC:M01AE01 887 1.0%
 
ATC:C10AA07 631 0.7%
 
ATC:C10AA05 622 0.7%
 
ATC:N03AX16 618 0.7%
 
ATC:A11AA06 611 0.7%
 
ATC:N06BA04 587 0.6%
 
ATC:A11CC05 545 0.6%
 
ATC:A07FA01 531 0.6%
 
Other values (1099) 77731 85.9%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length11
Mean length10.53546554
Min length4
Scatter

B
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
60183
1
30271
ValueCountFrequency (%) 
0 60183 66.5%
 
1 30271 33.5%
 

B_Budget
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
47212
1
43242
ValueCountFrequency (%) 
0 47212 52.2%
 
1 43242 47.8%
 
Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
EA
75770
PAC
 
14317
other_unit
 
367
ValueCountFrequency (%) 
EA 75770 83.8%
 
PAC 14317 15.8%
 
other_unit 367 0.4%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length10
Mean length2.190737834
Min length2
Scatter

Budget_Group
Categorical

Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
B_Budget
43242
E_Budget
22984
A_Budget
18708
other_Budget
 
5520
ValueCountFrequency (%) 
B_Budget 43242 47.8%
 
E_Budget 22984 25.4%
 
A_Budget 18708 20.7%
 
other_Budget 5520 6.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length12
Mean length8.244101974
Min length8
Scatter

C
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
1
49305
0
41149
ValueCountFrequency (%) 
1 49305 54.5%
 
0 41149 45.5%
 

Chemical_/_biological
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing7502
Missing (%)8.3%
Memory size706.8 KiB
1
79971
2
 
2981
ValueCountFrequency (%) 
1 79971 88.4%
 
2 2981 3.3%
 
(Missing) 7502 8.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

chronic
Categorical

Distinct count3
Unique (%)< 0.1%
Missing376
Missing (%)0.4%
Memory size706.8 KiB
0
51001
1
39077
ValueCountFrequency (%) 
0 51001 56.4%
 
1 39077 43.2%
 
(Missing) 376 0.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter
Distinct count3
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size706.8 KiB
ave
74755
pred
15698
ValueCountFrequency (%) 
ave 74755 82.6%
 
pred 15698 17.4%
 
(Missing) 1 < 0.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.17355783
Min length3
Scatter
Distinct count3
Unique (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size706.8 KiB
1
74755
0
15698
(Missing)
 
1
ValueCountFrequency (%) 
1 74755 82.6%
 
0 15698 17.4%
 
(Missing) 1 < 0.1%
 

consumption
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2220
Unique (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.281552312
Minimum0
Maximum15.29536379
Zeros7507
Zeros (%)8.3%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q16.728628613
median8.459775921
Q310.7676636
95-th percentile12.84698135
Maximum15.29536379
Range15.29536379
Interquartile range (IQR)4.039034987

Descriptive statistics

Standard deviation3.382993285
Coefficient of variation (CV)0.4084974842
Kurtosis0.6729187976
Mean8.281552312
Median Absolute Deviation (MAD)2.572532036
Skewness-0.8801192763
Sum749099.5328
Variance11.44464356
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.34657359 1.58902692 1.93560051 2.24990484 ... 14.10343288 14.25162119 14.29273439 15.00291843 15.29536379], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 7507 8.3%
 
6.933423026 133 0.1%
 
7.001245622 126 0.1%
 
5.953243334 121 0.1%
 
10.21431226 120 0.1%
 
7.794823152 118 0.1%
 
8.646289765 117 0.1%
 
6.520621128 116 0.1%
 
11.82188701 113 0.1%
 
7.071573364 110 0.1%
 
Other values (2210) 81873 90.5%
 
ValueCountFrequency (%) 
0 7507 8.3%
 
0.6931471806 25 < 0.1%
 
1.098612289 20 < 0.1%
 
1.386294361 16 < 0.1%
 
1.791759469 2 < 0.1%
 
ValueCountFrequency (%) 
15.29536379 60 0.1%
 
15.01487305 60 0.1%
 
14.99096382 60 0.1%
 
14.30600347 60 0.1%
 
14.2794653 60 0.1%
 

consumption_previous_year
Categorical

HIGH CARDINALITY
Distinct count2746
Unique (%)3.0%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
0
 
3745
12687
 
106
9622
 
94
11371
 
87
17716
 
83
Other values (2741)
86339
ValueCountFrequency (%) 
0 3745 4.1%
 
12687 106 0.1%
 
9622 94 0.1%
 
11371 87 0.1%
 
17716 83 0.1%
 
5770 83 0.1%
 
454770 79 0.1%
 
3530 70 0.1%
 
8341 62 0.1%
 
45662 60 0.1%
 
Other values (2736) 85985 95.1%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length7.278970526
Min length3
Scatter

Current_consumption
Real number (ℝ≥0)

ZEROS
Distinct count2207
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean104264.5402
Minimum0
Maximum5666490
Zeros8473
Zeros (%)9.4%
Memory size353.5 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q1977
median5879
Q364308
95-th percentile520530
Maximum5666490
Range5666490
Interquartile range (IQR)63331

Descriptive statistics

Standard deviation322775.2459
Coefficient of variation (CV)3.095733653
Kurtosis101.134983
Mean104264.5402
Median Absolute Deviation (MAD)144491.2226
Skewness8.158516983
Sum9431144720
Variance1.041838594e+11
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 1.500000e+00 2.500000e+00 5.500000e+00 ... 1.677765e+06 1.707915e+06 1.974510e+06 4.293390e+06 5.666490e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 8473 9.4%
 
3355 154 0.2%
 
120 151 0.2%
 
1023 147 0.2%
 
180 137 0.2%
 
602 134 0.1%
 
763 129 0.1%
 
722 119 0.1%
 
3814 118 0.1%
 
1401 117 0.1%
 
Other values (2197) 80775 89.3%
 
ValueCountFrequency (%) 
0 8473 9.4%
 
1 1 < 0.1%
 
2 77 0.1%
 
3 26 < 0.1%
 
4 10 < 0.1%
 
ValueCountFrequency (%) 
5666490 60 0.1%
 
4368000 60 0.1%
 
4218780 60 0.1%
 
2010420 60 0.1%
 
1938600 60 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing80243
Missing (%)88.7%
Memory size706.8 KiB
0
10006
1
 
205
ValueCountFrequency (%) 
0 10006 11.1%
 
1 205 0.2%
 
(Missing) 80243 88.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.661341676
Min length1
Scatter

dangerous_substance
Categorical

MISSING
Distinct count3
Unique (%)< 0.1%
Missing80259
Missing (%)88.7%
Memory size706.8 KiB
0
9675
1
 
520
ValueCountFrequency (%) 
0 9675 10.7%
 
1 520 0.6%
 
(Missing) 80259 88.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.661872333
Min length1
Scatter

Date_of_basket_entry
Categorical

MISSING
HIGH CARDINALITY
Distinct count54
Unique (%)0.1%
Missing40977
Missing (%)45.3%
Memory size706.8 KiB
01.01.1995
23781
01.01.2000
 
4298
01.03.2001
 
3326
01.03.1999
 
2760
01.03.2002
 
2118
Other values (48)
13194
ValueCountFrequency (%) 
01.01.1995 23781 26.3%
 
01.01.2000 4298 4.8%
 
01.03.2001 3326 3.7%
 
01.03.1999 2760 3.1%
 
01.03.2002 2118 2.3%
 
01.01.2009 1418 1.6%
 
01.05.2006 1402 1.5%
 
01.03.2008 1070 1.2%
 
15.01.2015 853 0.9%
 
01.01.2010 790 0.9%
 
Other values (43) 7661 8.5%
 
(Missing) 40977 45.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length7.281911248
Min length4
Scatter

Description_Alternative_purchasing_group
Categorical

MISSING
HIGH CARDINALITY
Distinct count560
Unique (%)0.6%
Missing3423
Missing (%)3.8%
Memory size706.8 KiB
Hypertension
 
2963
Bact.Inf., Sys.
 
1889
Statines
 
1705
EPILEPSY- Anticonvulsants
 
1515
Pain, Mod/Sev
 
1352
Other values (554)
77607
ValueCountFrequency (%) 
Hypertension 2963 3.3%
 
Bact.Inf., Sys. 1889 2.1%
 
Statines 1705 1.9%
 
EPILEPSY- Anticonvulsants 1515 1.7%
 
Pain, Mod/Sev 1352 1.5%
 
הורדת חום ושיכוך כאב 1309 1.4%
 
Depression-SSRI 1217 1.3%
 
Diabetes Mell. 1027 1.1%
 
BPH 965 1.1%
 
טיפול אנטי פטרייתי 952 1.1%
 
Other values (549) 72137 79.7%
 
(Missing) 3423 3.8%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length30
Mean length15.2370155
Min length2
Scatter

Description_outline
Categorical

MISSING
HIGH CARDINALITY
Distinct count306
Unique (%)0.3%
Missing6729
Missing (%)7.4%
Memory size706.8 KiB
Hypertension
 
3180
Diabetes Mell.
 
3005
food adittive
 
2471
Not Designated
 
2280
Epilepsy
 
2016
Other values (300)
70773
ValueCountFrequency (%) 
Hypertension 3180 3.5%
 
Diabetes Mell. 3005 3.3%
 
food adittive 2471 2.7%
 
Not Designated 2280 2.5%
 
Epilepsy 2016 2.2%
 
Bact.Inf., Sys. 1893 2.1%
 
cosmetics 1868 2.1%
 
Statines 1705 1.9%
 
Antidepressants 1683 1.9%
 
Pain, Mild/Mod. 1602 1.8%
 
Other values (295) 62022 68.6%
 
(Missing) 6729 7.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceTrue
Contains non-wordsTrue

Length

Max length30
Mean length12.01320008
Min length3
Scatter

Description_outline_Binary
Real number (ℝ≥0)

MISSING
Distinct count213
Unique (%)0.2%
Missing6729
Missing (%)7.4%
Infinite0
Infinite (%)0.0%
Mean1.244544612
Minimum0.001193231988
Maximum3.794477722
Zeros0
Zeros (%)0.0%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0.001193231988
5-th percentile0.09426532706
Q10.404505644
median0.8973104551
Q31.911557645
95-th percentile3.585662124
Maximum3.794477722
Range3.79328449
Interquartile range (IQR)1.507052001

Descriptive statistics

Standard deviation1.050191326
Coefficient of variation (CV)0.8438358222
Kurtosis-0.06892555453
Mean1.244544612
Median Absolute Deviation (MAD)0.8715220875
Skewness0.9530542623
Sum104199.4976
Variance1.102901821
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3.794477722 3180 3.5%
 
3.585662124 3005 3.3%
 
2.948476243 2471 2.7%
 
2.817220724 2280 2.5%
 
2.405555688 2016 2.2%
 
2.258788154 1893 2.1%
 
2.228957354 1868 2.1%
 
2.03446054 1705 1.9%
 
2.008209436 1683 1.9%
 
1.911557645 1602 1.8%
 
Other values (202) 62022 68.6%
 
(Missing) 6729 7.4%
 
ValueCountFrequency (%) 
0.001193231988 10 < 0.1%
 
0.002386463976 10 < 0.1%
 
0.003579695964 15 < 0.1%
 
0.004772927953 8 < 0.1%
 
0.005966159941 15 < 0.1%
 
ValueCountFrequency (%) 
3.794477722 3180 3.5%
 
3.585662124 3005 3.3%
 
2.948476243 2471 2.7%
 
2.817220724 2280 2.5%
 
2.405555688 2016 2.2%
 

df_index
Real number (ℝ≥0)

UNIQUE
Distinct count90454
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean54598.84563
Minimum0
Maximum109199
Zeros1
Zeros (%)< 0.1%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile5448.65
Q127270.5
median54644.5
Q381873.75
95-th percentile103720.35
Maximum109199
Range109199
Interquartile range (IQR)54603.25

Descriptive statistics

Standard deviation31522.28374
Coefficient of variation (CV)0.5773434103
Kurtosis-1.200205829
Mean54598.84563
Median Absolute Deviation (MAD)27302.9025
Skewness-0.0008364606841
Sum4938683983
Variance993654372
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 109199.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6141 1 < 0.1%
 
70455 1 < 0.1%
 
25305 1 < 0.1%
 
31450 1 < 0.1%
 
29403 1 < 0.1%
 
19164 1 < 0.1%
 
17117 1 < 0.1%
 
23262 1 < 0.1%
 
21215 1 < 0.1%
 
107233 1 < 0.1%
 
Other values (90444) 90444 > 99.9%
 
ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
4 1 < 0.1%
 
5 1 < 0.1%
 
ValueCountFrequency (%) 
109199 1 < 0.1%
 
109198 1 < 0.1%
 
109197 1 < 0.1%
 
109196 1 < 0.1%
 
109195 1 < 0.1%
 

E_Budget
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
67470
1
22984
ValueCountFrequency (%) 
0 67470 74.6%
 
1 22984 25.4%
 

EA
Boolean

HIGH CORRELATION
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
1
75770
0
 
14684
ValueCountFrequency (%) 
1 75770 83.8%
 
0 14684 16.2%
 
Distinct count874
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
Minimum2006-03-06 00:00:00
Maximum2019-08-19 00:00:00
Mini histogram
Histogram
Histogram

European_patent_expires
Categorical

MISSING
Distinct count30
Unique (%)< 0.1%
Missing89166
Missing (%)98.6%
Memory size706.8 KiB
01.02.2015
168
01.06.2017
 
99
01.03.2016
 
98
01.10.2018
 
96
01.03.2017
 
81
Other values (24)
746
ValueCountFrequency (%) 
01.02.2015 168 0.2%
 
01.06.2017 99 0.1%
 
01.03.2016 98 0.1%
 
01.10.2018 96 0.1%
 
01.03.2017 81 0.1%
 
01.09.2019 65 0.1%
 
01.12.2022 61 0.1%
 
01.05.2020 60 0.1%
 
01.07.2018 59 0.1%
 
01.05.2019 53 0.1%
 
Other values (19) 448 0.5%
 
(Missing) 89166 98.6%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length4.085435691
Min length4
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
0
80781
1
 
9673
ValueCountFrequency (%) 
0 80781 89.3%
 
1 9673 10.7%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

For_adults
Categorical

MISSING
Distinct count2
Unique (%)< 0.1%
Missing86594
Missing (%)95.7%
Memory size706.8 KiB
1
3860
ValueCountFrequency (%) 
1 3860 4.3%
 
(Missing) 86594 95.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.871979128
Min length1
Scatter

Form_of_giving
Categorical

MISSING
Distinct count4
Unique (%)< 0.1%
Missing52783
Missing (%)58.4%
Memory size706.8 KiB
0
37643
17
 
22
15
 
6
ValueCountFrequency (%) 
0 37643 41.6%
 
17 22 < 0.1%
 
15 6 < 0.1%
 
(Missing) 52783 58.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length2.750912066
Min length1
Scatter

General_purpose
Categorical

HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
0
89029
6
 
842
2
 
378
1
 
205
ValueCountFrequency (%) 
0 89029 98.4%
 
6 842 0.9%
 
2 378 0.4%
 
1 205 0.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

General_purpose_
Categorical

HIGH CORRELATION
Distinct count4
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
0
89029
6
 
842
2
 
378
1
 
205
ValueCountFrequency (%) 
0 89029 98.4%
 
6 842 0.9%
 
2 378 0.4%
 
1 205 0.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

GENERY_FATHER
Categorical

MISSING
HIGH CARDINALITY
Distinct count678
Unique (%)0.7%
Missing53625
Missing (%)59.3%
Memory size706.8 KiB
3999001541
 
186
3999001291
 
179
3999019172
 
178
3999001511
 
177
3999001491
 
176
Other values (672)
35933
ValueCountFrequency (%) 
3999001541 186 0.2%
 
3999001291 179 0.2%
 
3999019172 178 0.2%
 
3999001511 177 0.2%
 
3999001491 176 0.2%
 
3999001490 174 0.2%
 
3999001542 171 0.2%
 
3999001150 171 0.2%
 
3999003522 167 0.2%
 
3999001280 165 0.2%
 
Other values (667) 35085 38.8%
 
(Missing) 53625 59.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length10
Mean length6.442943375
Min length4
Scatter

Inventory
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2247
Unique (%)2.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.353178613
Minimum0
Maximum15.68157028
Zeros10341
Zeros (%)11.4%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q17.139660336
median8.65347081
Q311.09560536
95-th percentile13.09956751
Maximum15.68157028
Range15.68157028
Interquartile range (IQR)3.955945027

Descriptive statistics

Standard deviation3.688092249
Coefficient of variation (CV)0.4415196203
Kurtosis0.5351412593
Mean8.353178613
Median Absolute Deviation (MAD)2.730679738
Skewness-0.982820625
Sum755578.4183
Variance13.60202444
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.54930614 1.44518588 2.13833306 2.60200334 ... 14.71652487 14.75657529 14.94675861 15.67182292 15.68157028], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 10341 11.4%
 
6.775366091 130 0.1%
 
5.993961427 120 0.1%
 
8.567696174 120 0.1%
 
8.802071337 120 0.1%
 
8.896588072 120 0.1%
 
7.700295203 117 0.1%
 
10.63135012 116 0.1%
 
11.21682136 115 0.1%
 
7.843064017 114 0.1%
 
Other values (2237) 79041 87.4%
 
ValueCountFrequency (%) 
0 10341 11.4%
 
1.098612289 8 < 0.1%
 
1.791759469 59 0.1%
 
1.945910149 32 < 0.1%
 
2.079441542 13 < 0.1%
 
ValueCountFrequency (%) 
15.68157028 60 0.1%
 
15.66207555 60 0.1%
 
15.09810996 60 0.1%
 
14.79540725 60 0.1%
 
14.71774334 60 0.1%
 

Inventory_of_consumption_months
Real number (ℝ≥0)

SKEWED
ZEROS
Distinct count32
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.324861255
Minimum0
Maximum786
Zeros32842
Zeros (%)36.3%
Memory size353.5 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile3
Maximum786
Range786
Interquartile range (IQR)2

Descriptive statistics

Standard deviation7.41955628
Coefficient of variation (CV)5.600251536
Kurtosis8370.552844
Mean1.324861255
Median Absolute Deviation (MAD)1.184277666
Skewness82.16846137
Sum119839
Variance55.0498154
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.00e+00 5.00e-01 1.50e+00 2.50e+00 3.50e+00 ... 2.55e+01 3.20e+01 1.27e+02 2.00e+02 7.86e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 32842 36.3%
 
1 30937 34.2%
 
2 16365 18.1%
 
3 6827 7.5%
 
4 1739 1.9%
 
5 626 0.7%
 
6 244 0.3%
 
7 157 0.2%
 
8 121 0.1%
 
10 104 0.1%
 
Other values (22) 492 0.5%
 
ValueCountFrequency (%) 
0 32842 36.3%
 
1 30937 34.2%
 
2 16365 18.1%
 
3 6827 7.5%
 
4 1739 1.9%
 
ValueCountFrequency (%) 
786 6 < 0.1%
 
255 2 < 0.1%
 
145 18 < 0.1%
 
109 15 < 0.1%
 
98 21 < 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing144
Missing (%)0.2%
Memory size706.8 KiB
1
56289
0
34021
ValueCountFrequency (%) 
1 56289 62.2%
 
0 34021 37.6%
 
(Missing) 144 0.2%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

Item_Type
Categorical

Distinct count5
Unique (%)< 0.1%
Missing405
Missing (%)0.4%
Memory size706.8 KiB
0
89677
1
 
252
6
 
60
3
 
60
ValueCountFrequency (%) 
0 89677 99.1%
 
1 252 0.3%
 
6 60 0.1%
 
3 60 0.1%
 
(Missing) 405 0.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

Loading_group
Categorical

Distinct count12
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
23
78717
11
 
3303
25
 
2814
13
 
1700
24
 
1186
Other values (7)
 
2734
ValueCountFrequency (%) 
23 78717 87.0%
 
11 3303 3.7%
 
25 2814 3.1%
 
13 1700 1.9%
 
24 1186 1.3%
 
12 839 0.9%
 
22 748 0.8%
 
15 471 0.5%
 
14 333 0.4%
 
19 206 0.2%
 
Other values (2) 137 0.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length2
Mean length1.998540695
Min length1
Scatter

Main_outline
Categorical

MISSING
HIGH CARDINALITY
Distinct count306
Unique (%)0.3%
Missing6729
Missing (%)7.4%
Memory size706.8 KiB
13
 
3180
12
 
3005
393
 
2471
0
 
2280
14
 
2016
Other values (300)
70773
ValueCountFrequency (%) 
13 3180 3.5%
 
12 3005 3.3%
 
393 2471 2.7%
 
0 2280 2.5%
 
14 2016 2.2%
 
60 1893 2.1%
 
392 1868 2.1%
 
432 1705 1.9%
 
420 1683 1.9%
 
54 1602 1.8%
 
Other values (295) 62022 68.6%
 
(Missing) 6729 7.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length2.557620448
Min length1
Scatter

Material_Type
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
ZHW1
83757
ZHW3
 
6697
ValueCountFrequency (%) 
ZHW1 83757 92.6%
 
ZHW3 6697 7.4%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length4
Min length4
Scatter

Material_Type_bool
Boolean

HIGH CORRELATION
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
1
83757
0
 
6697
ValueCountFrequency (%) 
1 83757 92.6%
 
0 6697 7.4%
 

month_year
Categorical

HIGH CORRELATION
Distinct count30
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
07/2018
 
3179
01/2019
 
3138
08/2018
 
3122
10/2018
 
3120
07/2019
 
3104
Other values (25)
74791
ValueCountFrequency (%) 
07/2018 3179 3.5%
 
01/2019 3138 3.5%
 
08/2018 3122 3.5%
 
10/2018 3120 3.4%
 
07/2019 3104 3.4%
 
01/2018 3098 3.4%
 
10/2017 3080 3.4%
 
05/2018 3079 3.4%
 
09/2019 3077 3.4%
 
03/2019 3072 3.4%
 
Other values (20) 59385 65.7%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length7
Min length7
Scatter

month_year_
Categorical

HIGH CORRELATION
Distinct count30
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
07/2018
 
3179
01/2019
 
3138
08/2018
 
3122
10/2018
 
3120
07/2019
 
3104
Other values (25)
74791
ValueCountFrequency (%) 
07/2018 3179 3.5%
 
01/2019 3138 3.5%
 
08/2018 3122 3.5%
 
10/2018 3120 3.4%
 
07/2019 3104 3.4%
 
01/2018 3098 3.4%
 
10/2017 3080 3.4%
 
05/2018 3079 3.4%
 
09/2019 3077 3.4%
 
03/2019 3072 3.4%
 
Other values (20) 59385 65.7%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length7
Mean length7
Min length7
Scatter

Must_prescribe
Categorical

Distinct count3
Unique (%)< 0.1%
Missing56
Missing (%)0.1%
Memory size706.8 KiB
1
57404
0
32994
ValueCountFrequency (%) 
1 57404 63.5%
 
0 32994 36.5%
 
(Missing) 56 0.1%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

Narcotic_/_psychotropic
Categorical

MISSING
Distinct count6
Unique (%)< 0.1%
Missing41151
Missing (%)45.5%
Memory size706.8 KiB
0
46277
1
 
1700
2
 
839
3
 
391
5
 
96
ValueCountFrequency (%) 
0 46277 51.2%
 
1 1700 1.9%
 
2 839 0.9%
 
3 391 0.4%
 
5 96 0.1%
 
(Missing) 41151 45.5%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

other_Budget
Boolean

HIGH CORRELATION
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
84934
1
 
5520
ValueCountFrequency (%) 
0 84934 93.9%
 
1 5520 6.1%
 

other_unit
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
90087
1
 
367
ValueCountFrequency (%) 
0 90087 99.6%
 
1 367 0.4%
 

PAC
Boolean

HIGH CORRELATION
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size88.5 KiB
0
76137
1
 
14317
ValueCountFrequency (%) 
0 76137 84.2%
 
1 14317 15.8%
 

Plant
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
7350
90454
ValueCountFrequency (%) 
7350 90454 100.0%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length6
Mean length6
Min length6
Scatter

Prediction
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2160
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.144863463
Minimum0
Maximum15.27477258
Zeros8927
Zeros (%)9.9%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q16.626717749
median8.390949465
Q310.73876344
95-th percentile12.80583454
Maximum15.27477258
Range15.27477258
Interquartile range (IQR)4.112045688

Descriptive statistics

Standard deviation3.508709916
Coefficient of variation (CV)0.4307880583
Kurtosis0.4730093702
Mean8.144863463
Median Absolute Deviation (MAD)2.669442736
Skewness-0.8707628432
Sum736735.4797
Variance12.31104528
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.34657359 1.86883481 2.67355377 2.83148024 ... 14.03102027 14.07667623 14.27130931 14.9147953 15.27477258], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 8927 9.9%
 
6.442540166 159 0.2%
 
6.144185634 141 0.2%
 
7.290974778 139 0.2%
 
7.166265974 137 0.2%
 
6.156978986 130 0.1%
 
6.395261598 125 0.1%
 
8.839856233 120 0.1%
 
11.40038367 120 0.1%
 
8.239065332 120 0.1%
 
Other values (2150) 80336 88.8%
 
ValueCountFrequency (%) 
0 8927 9.9%
 
0.6931471806 2 < 0.1%
 
1.386294361 1 < 0.1%
 
1.609437912 1 < 0.1%
 
1.791759469 1 < 0.1%
 
ValueCountFrequency (%) 
15.27477258 60 0.1%
 
14.94489451 60 0.1%
 
14.8846961 60 0.1%
 
14.28658923 60 0.1%
 
14.25602938 60 0.1%
 

PRICE
Real number (ℝ≥0)

Distinct count1451
Unique (%)1.6%
Missing4
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean1.855938488
Minimum0.009950330853
Maximum9.4809597
Zeros0
Zeros (%)0.0%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0.009950330853
5-th percentile0.1310282624
Q10.3920420878
median1.757857918
Q32.859339649
95-th percentile4.380149875
Maximum9.4809597
Range9.471009369
Interquartile range (IQR)2.467297561

Descriptive statistics

Standard deviation1.517936584
Coefficient of variation (CV)0.8178808689
Kurtosis0.8585050542
Mean1.855938488
Median Absolute Deviation (MAD)1.261593316
Skewness0.8630418938
Sum167869.6363
Variance2.304131472
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1310282624 1143 1.3%
 
0.1484200051 893 1.0%
 
0.1397619424 881 1.0%
 
0.2851789422 873 1.0%
 
0.1823215568 862 1.0%
 
0.2546422184 854 0.9%
 
0.1043600153 846 0.9%
 
0.4121096508 762 0.8%
 
2.541601993 733 0.8%
 
0.0953101798 715 0.8%
 
Other values (1440) 81888 90.5%
 
ValueCountFrequency (%) 
0.009950330853 173 0.2%
 
0.02955880224 195 0.2%
 
0.03922071315 151 0.2%
 
0.04879016417 210 0.2%
 
0.05826890812 177 0.2%
 
ValueCountFrequency (%) 
9.4809597 1 < 0.1%
 
9.431307156 28 < 0.1%
 
9.256069666 4 < 0.1%
 
9.145556487 5 < 0.1%
 
9.015209525 2 < 0.1%
 

Price_for_absolute_packaging
Real number (ℝ≥0)

ZEROS
Distinct count1843
Unique (%)2.0%
Missing4
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean3.39336019
Minimum0
Maximum10.8079154
Zeros1275
Zeros (%)1.4%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile1.16938136
Q12.151762203
median2.85532012
Q34.282206299
95-th percentile7.335086244
Maximum10.8079154
Range10.8079154
Interquartile range (IQR)2.130444096

Descriptive statistics

Standard deviation1.856955119
Coefficient of variation (CV)0.5472319516
Kurtosis0.641286598
Mean3.39336019
Median Absolute Deviation (MAD)1.448362879
Skewness0.9849268277
Sum306929.4292
Variance3.448282315
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 1275 1.4%
 
1.757857918 1040 1.1%
 
1.648658626 922 1.0%
 
2.541601993 649 0.7%
 
2.791165108 635 0.7%
 
1.458615023 611 0.7%
 
2.272125886 599 0.7%
 
1.945910149 583 0.6%
 
1.902107526 481 0.5%
 
1.386294361 480 0.5%
 
Other values (1832) 83175 92.0%
 
ValueCountFrequency (%) 
0 1275 1.4%
 
0.02955880224 52 0.1%
 
0.06765864847 60 0.1%
 
0.08617769624 75 0.1%
 
0.0953101798 179 0.2%
 
ValueCountFrequency (%) 
10.8079154 4 < 0.1%
 
10.62652188 1 < 0.1%
 
10.46598376 5 < 0.1%
 
10.32333606 1 < 0.1%
 
10.20502815 7 < 0.1%
 

Pure_OTC
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
0
67149
1
23305
ValueCountFrequency (%) 
0 67149 74.2%
 
1 23305 25.8%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

Quantity_in_absolute_packaging
Categorical

HIGH CARDINALITY
Distinct count54
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
1
32147
30
20321
28
 
6078
60
 
4679
20
 
4570
Other values (49)
22659
ValueCountFrequency (%) 
1 32147 35.5%
 
30 20321 22.5%
 
28 6078 6.7%
 
60 4679 5.2%
 
20 4570 5.1%
 
100 3030 3.3%
 
10 2182 2.4%
 
50 2030 2.2%
 
5 1623 1.8%
 
56 1516 1.7%
 
Other values (44) 12278 13.6%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length5
Mean length3.613085104
Min length3
Scatter

Quantity_in_Packaging-Absolute
Real number (ℝ≥0)

ZEROS
Distinct count54
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.19395494
Minimum0
Maximum448
Zeros1275
Zeros (%)1.4%
Memory size353.5 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
median20
Q330
95-th percentile90
Maximum448
Range448
Interquartile range (IQR)29

Descriptive statistics

Standard deviation28.61399747
Coefficient of variation (CV)1.233683412
Kurtosis18.15022935
Mean23.19395494
Median Absolute Deviation (MAD)20.0623727
Skewness2.832334298
Sum2097986
Variance818.760851
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 207. 217. 335. 424. 448. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 32147 35.5%
 
30 20321 22.5%
 
28 6078 6.7%
 
60 4679 5.2%
 
20 4570 5.1%
 
100 3030 3.3%
 
10 2182 2.4%
 
50 2030 2.2%
 
5 1623 1.8%
 
56 1516 1.7%
 
Other values (44) 12278 13.6%
 
ValueCountFrequency (%) 
0 1275 1.4%
 
1 32147 35.5%
 
2 1026 1.1%
 
3 663 0.7%
 
4 1165 1.3%
 
ValueCountFrequency (%) 
448 1 < 0.1%
 
400 36 < 0.1%
 
270 3 < 0.1%
 
224 3 < 0.1%
 
210 30 < 0.1%
 

Quantity_in_packing-relative
Real number (ℝ≥0)

ZEROS
Distinct count65
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.6325204
Minimum0
Maximum1000
Zeros64593
Zeros (%)71.4%
Memory size353.5 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q35
95-th percentile120
Maximum1000
Range1000
Interquartile range (IQR)5

Descriptive statistics

Standard deviation82.28814741
Coefficient of variation (CV)3.340630438
Kurtosis42.05369159
Mean24.6325204
Median Absolute Deviation (MAD)38.92203777
Skewness5.695056527
Sum2228110
Variance6771.339204
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0.00e+00 5.00e-01 2.50e+00 3.50e+00 4.50e+00 ... 4.52e+02 4.77e+02 6.25e+02 8.75e+02 1.00e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 64593 71.4%
 
15 3022 3.3%
 
100 2266 2.5%
 
10 2085 2.3%
 
50 1960 2.2%
 
30 1905 2.1%
 
5 1510 1.7%
 
20 1174 1.3%
 
3 1057 1.2%
 
500 992 1.1%
 
Other values (55) 9890 10.9%
 
ValueCountFrequency (%) 
0 64593 71.4%
 
1 863 1.0%
 
2 803 0.9%
 
3 1057 1.2%
 
4 145 0.2%
 
ValueCountFrequency (%) 
1000 115 0.1%
 
750 58 0.1%
 
500 992 1.1%
 
454 51 0.1%
 
450 121 0.1%
 

Safety_Stock
Real number (ℝ≥0)

ZEROS
HIGH CORRELATION
Distinct count2126
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.921032659
Minimum0
Maximum15.47226784
Zeros9495
Zeros (%)10.5%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q16.541029999
median8.048149102
Q310.62281404
95-th percentile12.59795594
Maximum15.47226784
Range15.47226784
Interquartile range (IQR)4.081784046

Descriptive statistics

Standard deviation3.495047017
Coefficient of variation (CV)0.4412362842
Kurtosis0.4302132916
Mean7.921032659
Median Absolute Deviation (MAD)2.632891965
Skewness-0.8280378059
Sum716489.0882
Variance12.21535365
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[ 0. 0.34657359 1.70059869 2.01267585 2.13833306 ... 14.34143051 14.3858663 14.88945292 15.45804062 15.47226784], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 9495 10.5%
 
7.119635638 136 0.2%
 
7.239214974 130 0.1%
 
6.135564891 126 0.1%
 
6.602587892 122 0.1%
 
7.493873887 121 0.1%
 
10.8062066 120 0.1%
 
7.400009517 120 0.1%
 
11.87214417 119 0.1%
 
11.31568112 119 0.1%
 
Other values (2116) 79846 88.3%
 
ValueCountFrequency (%) 
0 9495 10.5%
 
0.6931471806 19 < 0.1%
 
1.386294361 33 < 0.1%
 
1.609437912 1 < 0.1%
 
1.791759469 21 < 0.1%
 
ValueCountFrequency (%) 
15.47226784 60 0.1%
 
15.4438134 60 0.1%
 
15.00171636 60 0.1%
 
14.77718948 60 0.1%
 
14.633735 60 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing11
Missing (%)< 0.1%
Memory size706.8 KiB
no
76494
yes
 
13949
(Missing)
 
11
ValueCountFrequency (%) 
no 76494 84.6%
 
yes 13949 15.4%
 
(Missing) 11 < 0.1%
 
Distinct count3
Unique (%)< 0.1%
Missing11
Missing (%)< 0.1%
Memory size706.8 KiB
1
76494
0
 
13949
(Missing)
 
11
ValueCountFrequency (%) 
1 76494 84.6%
 
0 13949 15.4%
 
(Missing) 11 < 0.1%
 

Send_code_to_Omri
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
1
90454
ValueCountFrequency (%) 
1 90454 100.0%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

Serving_form
Categorical

MISSING
HIGH CARDINALITY
Distinct count53
Unique (%)0.1%
Missing7785
Missing (%)8.6%
Memory size706.8 KiB
TAB
37094
CAP
8375
CR
 
4923
COL
 
3135
CPL
 
2565
Other values (47)
26577
ValueCountFrequency (%) 
TAB 37094 41.0%
 
CAP 8375 9.3%
 
CR 4923 5.4%
 
COL 3135 3.5%
 
CPL 2565 2.8%
 
GEL 2051 2.3%
 
OIN 1977 2.2%
 
SOL 1665 1.8%
 
INJ 1639 1.8%
 
LIQ 1592 1.8%
 
Other values (42) 17653 19.5%
 
(Missing) 7785 8.6%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.031640392
Min length2
Scatter

Serving_form_Binary
Real number (ℝ≥0)

MISSING
Distinct count52
Unique (%)0.1%
Missing7785
Missing (%)8.6%
Infinite0
Infinite (%)0.0%
Mean22.18864604
Minimum0.00483132632
Maximum44.80330463
Zeros0
Zeros (%)0.0%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0.00483132632
5-th percentile0.5556025268
Q11.97963596
median10.11558948
Q344.80330463
95-th percentile44.80330463
Maximum44.80330463
Range44.7984733
Interquartile range (IQR)42.82366867

Descriptive statistics

Standard deviation20.55537735
Coefficient of variation (CV)0.9263916918
Kurtosis-1.924535159
Mean22.18864604
Median Absolute Deviation (MAD)20.29462424
Skewness0.1642905444
Sum1834313.18
Variance422.5235379
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
44.80330463 37094 41.0%
 
10.11558948 8375 9.3%
 
5.946154868 4923 5.4%
 
3.786552003 3135 3.5%
 
3.098088003 2565 2.8%
 
2.477262571 2051 2.3%
 
2.387883034 1977 2.2%
 
2.160810697 1665 1.8%
 
1.97963596 1639 1.8%
 
1.922867875 1592 1.8%
 
Other values (41) 17653 19.5%
 
(Missing) 7785 8.6%
 
ValueCountFrequency (%) 
0.00483132632 4 < 0.1%
 
0.0060391579 5 < 0.1%
 
0.02174096844 18 < 0.1%
 
0.03744277898 31 < 0.1%
 
0.04589760004 76 0.1%
 
ValueCountFrequency (%) 
44.80330463 37094 41.0%
 
10.11558948 8375 9.3%
 
5.946154868 4923 5.4%
 
3.786552003 3135 3.5%
 
3.098088003 2565 2.8%
 

skucode2
Categorical

HIGH CARDINALITY
Distinct count3197
Unique (%)3.5%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
10000005408
 
60
10000004918
 
60
10000006433
 
60
10000003498
 
60
10000005462
 
60
Other values (3192)
90154
ValueCountFrequency (%) 
10000005408 60 0.1%
 
10000004918 60 0.1%
 
10000006433 60 0.1%
 
10000003498 60 0.1%
 
10000005462 60 0.1%
 
10000005276 60 0.1%
 
10000006997 60 0.1%
 
10000006547 60 0.1%
 
10000003366 60 0.1%
 
10000005409 60 0.1%
 
Other values (3187) 89854 99.3%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length11
Mean length11
Min length11
Scatter
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
1
89900
0
 
554
ValueCountFrequency (%) 
1 89900 99.4%
 
0 554 0.6%
 

Sourcing_source
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
ארץ
89900
חו"ל
 
554
ValueCountFrequency (%) 
ארץ 89900 99.4%
 
חו"ל 554 0.6%
 

Composition

Contains charsFalse
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length4
Mean length3.00612466
Min length3
Scatter

status
Categorical

CONST
HIGH CORRELATION
Distinct count1
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
1
90454
ValueCountFrequency (%) 
1 90454 100.0%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

storecode
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
3224
45930
3315
44524
ValueCountFrequency (%) 
3224 45930 50.8%
 
3315 44524 49.2%
 

Composition

Contains charsFalse
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length6
Mean length6
Min length6
Scatter

Toxic_item
Categorical

MISSING
Distinct count5
Unique (%)< 0.1%
Missing7200
Missing (%)8.0%
Memory size706.8 KiB
0
82851
1
 
333
3
 
55
2
 
15
ValueCountFrequency (%) 
0 82851 91.6%
 
1 333 0.4%
 
3 55 0.1%
 
2 15 < 0.1%
 
(Missing) 7200 8.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length3
Mean length3
Min length3
Scatter

TranQuantity
Real number (ℝ≥0)

Distinct count1943
Unique (%)2.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.285248308
Minimum0
Maximum9.455714972
Zeros447
Zeros (%)0.5%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.6931471806
Q11.386294361
median3.044522438
Q34.875197323
95-th percentile6.867974409
Maximum9.455714972
Range9.455714972
Interquartile range (IQR)3.488902962

Descriptive statistics

Standard deviation2.042987608
Coefficient of variation (CV)0.6218670299
Kurtosis-0.8994655829
Mean3.285248308
Median Absolute Deviation (MAD)1.772242289
Skewness0.4219250626
Sum297163.8505
Variance4.173798367
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.34657359 0.89587973 1.70059869 2.01267585 ... 8.45233405 8.79118137 8.94357094 9.26538751 9.45571497], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0.6931471806 10724 11.9%
 
1.098612289 7477 8.3%
 
1.386294361 5285 5.8%
 
1.609437912 4096 4.5%
 
4.110873864 3589 4.0%
 
3.433987204 3294 3.6%
 
1.791759469 2928 3.2%
 
1.945910149 2473 2.7%
 
4.795790546 2067 2.3%
 
4.510859507 1843 2.0%
 
Other values (1933) 46678 51.6%
 
ValueCountFrequency (%) 
0 447 0.5%
 
0.6931471806 10724 11.9%
 
1.098612289 7477 8.3%
 
1.386294361 5285 5.8%
 
1.609437912 4096 4.5%
 
ValueCountFrequency (%) 
9.455714972 2 < 0.1%
 
9.427143868 1 < 0.1%
 
9.412546252 1 < 0.1%
 
9.346705246 2 < 0.1%
 
9.329455853 1 < 0.1%
 

type_of_packeging
Categorical

MISSING
Distinct count7
Unique (%)< 0.1%
Missing85083
Missing (%)94.1%
Memory size706.8 KiB
BOX
3632
TUB
773
BOT
770
PKG
 
159
BAG
 
24
ValueCountFrequency (%) 
BOX 3632 4.0%
 
TUB 773 0.9%
 
BOT 770 0.9%
 
PKG 159 0.2%
 
BAG 24 < 0.1%
 
KIT 13 < 0.1%
 
(Missing) 85083 94.1%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.940621752
Min length3
Scatter

U#S#_Patent_Expires
Categorical

MISSING
Distinct count33
Unique (%)< 0.1%
Missing88923
Missing (%)98.3%
Memory size706.8 KiB
01.03.2016
 
132
01.02.2018
 
117
01.10.2020
 
113
01.07.2018
 
107
01.10.2018
 
96
Other values (27)
966
ValueCountFrequency (%) 
01.03.2016 132 0.1%
 
01.02.2018 117 0.1%
 
01.10.2020 113 0.1%
 
01.07.2018 107 0.1%
 
01.10.2018 96 0.1%
 
01.05.2020 86 0.1%
 
01.03.2017 81 0.1%
 
01.12.2019 71 0.1%
 
01.03.2020 66 0.1%
 
01.06.2018 65 0.1%
 
Other values (22) 597 0.7%
 
(Missing) 88923 98.3%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length4.101554381
Min length4
Scatter

Validity_of_Ministry_of_Health_registration
Categorical

MISSING
HIGH CARDINALITY
Distinct count83
Unique (%)0.1%
Missing85912
Missing (%)95.0%
Memory size706.8 KiB
28.02.2015
 
250
30.04.2015
 
247
30.11.2012
 
244
30.11.2013
 
181
31.01.2007
 
180
Other values (77)
3440
ValueCountFrequency (%) 
28.02.2015 250 0.3%
 
30.04.2015 247 0.3%
 
30.11.2012 244 0.3%
 
30.11.2013 181 0.2%
 
31.01.2007 180 0.2%
 
30.09.2012 142 0.2%
 
31.10.2013 120 0.1%
 
31.03.2015 119 0.1%
 
31.05.2014 113 0.1%
 
31.01.2008 113 0.1%
 
Other values (72) 2833 3.1%
 
(Missing) 85912 95.0%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsTrue

Length

Max length10
Mean length4.301280209
Min length4
Scatter

VENDOR
Categorical

HIGH CARDINALITY
Distinct count150
Unique (%)0.2%
Missing594
Missing (%)0.7%
Memory size706.8 KiB
400059
 
8701
400057
 
4983
408668
 
4824
400095
 
4199
400045
 
3597
Other values (144)
63556
ValueCountFrequency (%) 
400059 8701 9.6%
 
400057 4983 5.5%
 
408668 4824 5.3%
 
400095 4199 4.6%
 
400045 3597 4.0%
 
406885 3543 3.9%
 
407214 2828 3.1%
 
400026 2778 3.1%
 
410232 2705 3.0%
 
400032 2203 2.4%
 
Other values (139) 49499 54.7%
 

Composition

Contains charsTrue
Contains digitsTrue
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length6
Mean length5.986866252
Min length4
Scatter

VENDOR_Binary
Real number (ℝ≥0)

Distinct count123
Unique (%)0.1%
Missing594
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean3.072614508
Minimum0.00110984096
Maximum9.656726191
Zeros0
Zeros (%)0.0%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0.00110984096
5-th percentile0.1720253488
Q11.002186387
median2.348423471
Q34.66022219
95-th percentile9.656726191
Maximum9.656726191
Range9.65561635
Interquartile range (IQR)3.658035803

Descriptive statistics

Standard deviation2.691063776
Coefficient of variation (CV)0.8758221277
Kurtosis0.7995755842
Mean3.072614508
Median Absolute Deviation (MAD)2.087136567
Skewness1.230869029
Sum276105.1397
Variance7.241824246
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
9.656726191 8701 9.6%
 
5.530337503 4983 5.5%
 
5.35387279 4824 5.3%
 
4.66022219 4199 4.6%
 
3.992097932 3597 4.0%
 
3.932166521 3543 3.9%
 
3.138630234 2828 3.1%
 
3.083138186 2778 3.1%
 
3.002119796 2705 3.0%
 
2.444979634 2203 2.4%
 
Other values (112) 49499 54.7%
 
ValueCountFrequency (%) 
0.00110984096 6 < 0.1%
 
0.00221968192 6 < 0.1%
 
0.003329522879 12 < 0.1%
 
0.006659045759 18 < 0.1%
 
0.007768886719 14 < 0.1%
 
ValueCountFrequency (%) 
9.656726191 8701 9.6%
 
5.530337503 4983 5.5%
 
5.35387279 4824 5.3%
 
4.66022219 4199 4.6%
 
3.992097932 3597 4.0%
 

volume
Real number (ℝ≥0)

Distinct count739
Unique (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.847270402
Minimum0
Maximum9.207736986
Zeros127
Zeros (%)0.1%
Memory size706.8 KiB
Mini histogram

Quantile statistics

Minimum0
5-th percentile1.386294361
Q11.945910149
median4.418840608
Q35.501258211
95-th percentile6.609349243
Maximum9.207736986
Range9.207736986
Interquartile range (IQR)3.555348061

Descriptive statistics

Standard deviation1.927719632
Coefficient of variation (CV)0.501061644
Kurtosis-1.430752622
Mean3.847270402
Median Absolute Deviation (MAD)1.778535451
Skewness0.0101202821
Sum348000.9969
Variance3.71610298
Histogram
Histogram with fixed size bins (bins=10)
Histogram
Histogram with variable size bins (bins=[0. 0.34657359 0.89587973 1.24245332 2.01267585 ... 8.36082047 8.37848851 8.40416404 8.7215198 9.20773699], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.386294361 7230 8.0%
 
1.609437912 5559 6.1%
 
1.791759469 4581 5.1%
 
1.945910149 4036 4.5%
 
2.079441542 3087 3.4%
 
1.098612289 3075 3.4%
 
2.302585093 2316 2.6%
 
2.197224577 2144 2.4%
 
2.397895273 1329 1.5%
 
2.48490665 1087 1.2%
 
Other values (729) 56010 61.9%
 
ValueCountFrequency (%) 
0 127 0.1%
 
0.6931471806 947 1.0%
 
1.098612289 3075 3.4%
 
1.386294361 7230 8.0%
 
1.609437912 5559 6.1%
 
ValueCountFrequency (%) 
9.207736986 2 < 0.1%
 
9.019058794 11 < 0.1%
 
8.42398081 60 0.1%
 
8.384347278 17 < 0.1%
 
8.37262974 54 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
0
57181
1
33273
ValueCountFrequency (%) 
0 57181 63.2%
 
1 33273 36.8%
 

Volume_marker
Categorical

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size706.8 KiB
LOW
57181
HIGH
33273
ValueCountFrequency (%) 
LOW 57181 63.2%
 
HIGH 33273 36.8%
 

Composition

Contains charsTrue
Contains digitsFalse
Contains whitespaceFalse
Contains non-wordsFalse

Length

Max length4
Mean length3.367844429
Min length3
Scatter

Correlations

Missing values

Sample

First rows

AA_BudgetA_group_of_materialsA_group_of_materials_BinaryABCAffiliation_GroupAffiliation_Group_BinaryAlternative_purchasing_groupATCBB_BudgetBasic_unit_of_measureBudget_GroupCChemical_/_biologicalchronicConsumer_managementConsumer_management_Boolconsumptionconsumption_previous_yearCurrent_consumptionDangerous_material_is_charged_with_a_permitdangerous_substanceDate_of_basket_entryDescription_Alternative_purchasing_groupDescription_outlineDescription_outline_Binarydf_indexE_BudgetEAEstablishment_date_of_the_itemEuropean_patent_expiresExceptional_policyFor_adultsForm_of_givingGeneral_purposeGeneral_purpose_GENERY_FATHERInventoryInventory_of_consumption_monthsItem_in_health_basketItem_TypeLoading_groupMain_outlineMaterial_TypeMaterial_Type_boolmonth_yearmonth_year_Must_prescribeNarcotic_/_psychotropicother_Budgetother_unitPACPlantPredictionPRICEPrice_for_absolute_packagingPure_OTCQuantity_in_absolute_packagingQuantity_in_Packaging-AbsoluteQuantity_in_packing-relativeSafety_StockSeasonalitySeasonality_boolSend_code_to_OmriServing_formServing_form_Binaryskucode2source_bollSourcing_sourcestatusstorecodeToxic_itemTranQuantitytype_of_packegingU#S#_Patent_ExpiresValidity_of_Ministry_of_Health_registrationVENDORVENDOR_BinaryvolumeVolume_boolVolume_marker
000201405.724555B155.8023191180ATC:G03AA0911PACB_Budget010ave1.08.759355830628491NoneNone01.04.2005Oral contraceptiveOral Contra.1.0930010002006-03-06None0None000None9.08387011023171ZHW1103/201703/20171000173508.9027282.3379525.2860420212108.449343no1.01TAB44.803305100000057191ארץ1322402.484907BOXNoneNone4086685.3538734.6249730LOW
1002019016.233172C2016.0176701054ATC:N06AA0401EAB_Budget111ave1.010.18304930642034920NoneNone01.01.1995Depression-TricyclicAntidepressants2.0082091012006-03-06None0None000399900542211.13533321023420ZHW1102/201902/201910000735010.1390730.1906201.98787403030010.342097no1.01TAB44.803305100000064271ארץ1322404.795791NoneNoneNone4000954.6602221.3862940LOW
200202704.767523C2410.0905581351ATC:D08AX0800EAE_Budget110ave1.07.18690113544222000Noneחיטוי ידייםcosmetics2.2289572112016-05-18None0NoneNone00None6.77536600023392ZHW1107/201707/20170NaN00073507.1163942.7107132.7107131115006.829794no1.01GEL2.477263100000018801ארץ1331501.098612NoneNoneNone1242072.4127946.8480051HIGH
300201804.087236C194.3677531156ATC:M01AH0101EAB_Budget110ave1.010.75947652541059330NoneNoneNoneNSAIDS-COX 2 inhibtorsRheum. Arth.1.7624044012006-03-06None0None000399901065511.3781481002365ZHW1102/201702/201710000735010.7226950.4446861.88707001010010.894125no1.01CAP10.115589100000067321ארץ1322403.433987NoneNoneNone4000772.2341102.3978950LOW
4002012010.418206B1310.6769741605ATC:C08CA0111EAB_Budget011ave1.00.00000000NoneNone01.01.2000Calcium Chanell BlockersCalcium Chanell Blockers0.4068925012006-09-26None0NoneNone0039990191720.00000001023431ZHW1104/201704/20171000073500.0000000.1310281.3350010202000.000000no1.01TAB44.803305100000045221ארץ1331508.077447NoneNoneNone4000599.6567261.9459101HIGH
500101502.248145C721.080066NoneZRP:102UB0100EAother_Budget1NaN1ave1.00.00000000NoneNone01.03.2001NoneNoneNaN6012009-06-03None0NoneNone00None0.00000001023NoneZHW3003/201903/20191NaN10073500.0000003.5213480.00000000000.000000no1.01NoneNaN100000038971ארץ13315NaN1.609438NoneNoneNone4000442.3506436.3080981HIGH
600202204.189775C224.4969631946ATC:S01XA3000PACE_Budget110ave1.07.265430177511852NoneNoneNoneטיפות ליובש בעינייםArtificial Tears1.0858417102010-12-27None0NoneNone00None7.99057720023128ZHW1105/201805/20180NaN00173507.3072023.2861616.7149951323207.342779no1.01COL3.786552100000034781ארץ1331502.397895NoneNoneNone4000061.0809856.2265370LOW
7002010012.387400B1112.7620101354ATC:A01AB0911EAB_Budget010ave1.08.155075394544049NoneNone01.01.1995טיפול אנטי פטרייתיFungal Inf, Oroph.0.1205168012006-03-06None0None000None7.8284360102383ZHW1101/201801/20180000073508.0882552.6433342.643334011407.462215no1.01GEL2.477263100000062951ארץ1331501.609438NoneNone30.04.20121174690.5360535.3706380LOW
800101000.814801C2410.0905581429ZRP:A21AD00EAE_Budget1NaN0ave1.06.2441675821712NoneNoneNoneסד תמיכה לידNoneNaN9112006-03-06None0NoneNone00None7.15695620023NoneZHW3005/201805/20180NaN00073506.1800173.4094963.40949611106.410175no1.01NoneNaN100000069921ארץ13224NaN1.098612NoneNoneNone4001230.8368206.6515720LOW
9002019016.233172C2016.0176701017ATC:N07CA0201EAB_Budget111ave1.012.1169302.15885e+06223275NoneNone01.01.1995Antivertigo preparationsMeniere's Dis.0.21358911012006-03-06None0None000None12.54013511023209ZHW1106/201706/201710000735012.0862640.1823221.79175902525011.760254no1.01TAB44.803305100000066441ארץ1322406.356108NoneNone30.09.20124019741.2152762.0794421HIGH

Last rows

AA_BudgetA_group_of_materialsA_group_of_materials_BinaryABCAffiliation_GroupAffiliation_Group_BinaryAlternative_purchasing_groupATCBB_BudgetBasic_unit_of_measureBudget_GroupCChemical_/_biologicalchronicConsumer_managementConsumer_management_Boolconsumptionconsumption_previous_yearCurrent_consumptionDangerous_material_is_charged_with_a_permitdangerous_substanceDate_of_basket_entryDescription_Alternative_purchasing_groupDescription_outlineDescription_outline_Binarydf_indexE_BudgetEAEstablishment_date_of_the_itemEuropean_patent_expiresExceptional_policyFor_adultsForm_of_givingGeneral_purposeGeneral_purpose_GENERY_FATHERInventoryInventory_of_consumption_monthsItem_in_health_basketItem_TypeLoading_groupMain_outlineMaterial_TypeMaterial_Type_boolmonth_yearmonth_year_Must_prescribeNarcotic_/_psychotropicother_Budgetother_unitPACPlantPredictionPRICEPrice_for_absolute_packagingPure_OTCQuantity_in_absolute_packagingQuantity_in_Packaging-AbsoluteQuantity_in_packing-relativeSafety_StockSeasonalitySeasonality_boolSend_code_to_OmriServing_formServing_form_Binaryskucode2source_bollSourcing_sourcestatusstorecodeToxic_itemTranQuantitytype_of_packegingU#S#_Patent_ExpiresValidity_of_Ministry_of_Health_registrationVENDORVENDOR_BinaryvolumeVolume_boolVolume_marker
9044400201308.538320C148.8459411517ATC:D08AX0101EAB_Budget11NaNave1.07.830028281503399NoneNone01.01.1995תכשיר לחיטויAntiseptic0.943847109189012014-08-24None0NoneNone00None8.13446811023135ZHW1102/201702/2017NaNNaN00073507.7894551.4539531.4539530111007.473637no1.01SOL2.160811100000024771ארץ1331501.098612NoneNoneNone4001711.7036065.8944031HIGH
9044500201308.538320C148.8459411519ATC:D02AC0200EAE_Budget110pred0.06.80350594261085NoneNoneNoneתכשיר רחצה טיפולי - תינוקותDry Skin1.450970109190112010-06-09None0NoneNone00None7.35500210025142ZHW1106/201806/20180NaN00073506.8585653.4384933.4384931115006.634633yes0.01OIL0.359934100000036221ארץ1331501.098612NoneNoneNone4000442.3506436.8936561HIGH
9044610201603.215101A173.1905021651ATC:J07AJ5201EAB_Budget020pred0.00.00000000NoneNoneNoneDPT Vac.DPT Vac.0.003580109191012011-03-22None1NoneNone0039990021400.0000000101196ZHW1101/201701/20171NaN00073500.0000004.1616924.16169201100.000000no1.01SRG0.843066100000034061ארץ1331500.000000NoneNoneNone4001640.0033305.0751740LOW
9044700202401.068393B2410.0905581401ATC:V06DB1511EAB_Budget010ave1.09.61587219611019770NoneNone01.03.2008מזון ייעודיMetab. Disord.0.050116109192012014-11-04None0NoneNone00None9.29293401025107ZHW1104/201904/20190NaN00073509.7011272.3035852.3035851112209.095715no1.01LIQ1.922868100000024081ארץ1331504.110874NoneNoneNone4018820.9244986.1441861HIGH
9044800201804.087236B194.3677531076ATC:M04AC0111EAB_Budget011ave1.013.0460465.31108e+06619170NoneNone01.01.1995FMFGout0.218361109193012006-03-06None0None000None12.7310110102375ZHW1101/201701/201715000735013.0194040.3001052.44234703030012.352901no1.01TAB44.803305100000064741ארץ1322407.170888NoneNoneNone4000453.9920981.0986121HIGH
90449002019016.233172C2016.0176701823ATC:N02AA0501EAB_Budget110ave1.06.5424728445861NoneNoneNonePain, Mod/SevPain, Mod/Sev1.773143109195012013-10-14None0NoneNone00None6.7007311001359ZHW1103/201803/20181100073506.5957813.5192773.519277011306.658011no1.01SYR1.322576100000027041ארץ1331501.609438NoneNoneNone4000453.9920985.1298990LOW
9045000201308.538320C148.8459411352ATC:D08AG0201EAB_Budget110pred0.08.718173749346830NoneNone01.01.1995חיטוי נגעים בעורAntiseptic0.943847109196012006-03-06None0None00039990211508.56769601023135ZHW1103/201803/20180000073508.5020801.5062971.506297011158.145550yes0.01OIN2.387883100000067841ארץ1331502.995732NoneNoneNone4000575.5303384.9344741HIGH
90451002010012.387400C1112.7620101375ATC:A07BB0101EAB_Budget110ave1.011.155879637500116040NoneNone01.01.1995טיפול בשלשול וכאב בטןDiarrhea0.742190109197012013-07-01None0NoneNone00399900254011.5125351102347ZHW1106/201906/20190NaN000735010.8868200.2546421.91692302020011.313840no1.01TAB44.803305100000027931ארץ1331505.484797NoneNoneNone4000263.0831381.9459100LOW
9045200201501.523755C161.5262291694ATC:H02AB0701EAB_Budget111ave1.012.0400241.913e+06221300NoneNone01.01.1995GlucocorticoidGlucocorticoid0.509510109198012006-03-06None0None000None12.22047311023141ZHW1109/201709/201710000735011.9958820.1397622.7725890100100012.104544no1.01TAB44.803305100000066121ארץ1322405.707110NoneNoneNone4000575.5303380.0000000LOW
9045301202204.189775B224.4969631082ATC:S01EA0510EAA_Budget011ave1.09.13162210841412071NoneNone01.10.2005Glaucoma alpha 2 agonistGlaucoma1.468869109199012006-03-06None0None00039990014448.7577840102315ZHW1109/201909/20191000073509.0806872.8553202.85532001158.438583no1.01COL3.786552100000058691ארץ1331503.713572NoneNoneNone4000360.8423694.4188410LOW